DECLARE @SomeExampleTable TABLE (ID TINYINT,SomeTextValue CHAR(4));

/*GOOD - Notice how individual inserts are part of the same logical execution (batch)
You also get the added benefit of a more strict transaction isolation for test work.  
If any single insert fails within this statement the whole thing fails.*/
INSERT INTO @SomeExampleTable (ID,SomeTextValue)
VALUES
	(1,'ABCD'),
	(2,'ABCD'),
	(3,'ABCD')

--Show how many rows were effected by the last executed batch
SELECT @@ROWCOUNT AS RowsInBatch

DELETE FROM @SomeExampleTable WHERE 1=1
	
--BAD - Notice how individual inserts are seperate and therfore each is its own logical execution (batch).
INSERT INTO @SomeExampleTable (ID,SomeTextValue) VALUES (1,'ABCD')
INSERT INTO @SomeExampleTable (ID,SomeTextValue) VALUES (2,'ABCD')
INSERT INTO @SomeExampleTable (ID,SomeTextValue) VALUES (3,'ABCD')

--Show  how many rows were effected by the last executed batch
SELECT @@ROWCOUNT AS RowsInBatch